generate a comma separated file from excel for mac

Generate A Comma Separated File From Excel Full Site Gannett

Save 90 Local Sports Things to Do Business Travel Politics Opinions Homes Subscribe Archives Nation Jobs More Cars Video Apartments Shopping Classifieds Insider azcentral tickets Lottery Obituaries E-Newspaper Investigations Comics Buy Photos Apps Giving Back New Home Central Monsoons Business Directory Member Guide Traffic Moonlighting Advertise with Us USA TODAY NETWORK Public Notices Subscribe Home Local Sports Things to Do Nation Now Business Travel Explore Politics Opinion Investigations Marketplace Insider Advertise with Us Obituaries Archives Weather Subscribe Giving Rights to Folders in SharePoint How to Import Gmail Labels to Outlook How to Create Pipe Delimited Files in Excel 2010 by Kirk Bennet Related Articles Giving Rights to Folders in SharePoint How to Import Gmail Labels to Outlook How to Do a Nested Table in Word How to Import an Old Canon Fax Address Book to a New Computer How to Convert a PowerPoint to Word and Make It Editable How to Get a GIF Into Word Share on Facebook While you can use Microsoft Excel 2010 in your business to create complex spreadsheets for your clients and employees, the program also allows you to export existing documents in various formats for other programs.

For example, Excel can export data in CSV format, but uses commas to delimit the values by default.

You can change this behavior and create pipe delimited files by configuring your Windows operating systems Region and Language settings.

Step 1 Click Start Control Panel Clock, Language, and Region Region and Language to open the Region and Language window.

Step 2 Click the Additional Settings button on the Formats tab to open the Customize Format window.

Step 3 Insert the pipe symbol (without the quotes) in the List Separator field, and then click Apply to apply the settings.

Do not click OK to avoid closing the Customize Format window.

Step 4 Launch Microsoft Office Excel 2010 and open the document that you want to export in pipe delimited format.

Step 6 Select CSV (Comma delimited) (.csv) in the Save As Type box, type a name for the delimited file in the File Name field, select the destination folder, and then click the Save button to create the pipe delimited file.

Step 7 Switch to the Customize Format window, insert a comma in the List Separator field, and then click Apply and OK to use the default list separator.

Step 8 Click Apply and then OK to close the Region and Language window.

He covers topics in nutrition, health, gardening, home improvement and information technology.

Generate A Comma Separated File From Excel Full Site Gannett

Services About azcentral.com Contact Republic Media azcentral FAQ Advertise with Us Circulation FAQ and contact Work With Us Terms of Service Privacy NoticeYour California Privacy Rights Community Rules Do not sell my data Cookie policy Ad Choices The Arizona Republic Online Obituaries Video Photos Lavozarizona.com Lottery results Giving Back Advertising Terms and Conditions Archives Member Guide Our Partners Jobs Cars Homes Find and Save Classifieds GO Digital Help Terms of Service Privacy NoticeYour California Privacy Rights Do not sell my data Cookie policy Ad Choices Full Site Gannett 2019.

Generate A Comma Separated File From Excel For Mac