Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2020, 04:02 AM
otuatail otuatail is offline convert spreadsheet to comma seperated Windows 7 64bit convert spreadsheet to comma seperated Office 2007
Competent Performer
convert spreadsheet to comma seperated
 
Join Date: Jun 2012
Posts: 148
otuatail is on a distinguished road
Default convert spreadsheet to comma seperated

Hi. I have a spread sheet with 3 columns. This is a very large amount of data. I want to save it as a text file but the only option (Office 2007) is TEXT tab separated text.



I want to import this into a database table. I could do with a comma separated text file.

how do I achieve this?
Reply With Quote
  #2  
Old 03-13-2020, 09:34 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline convert spreadsheet to comma seperated Windows 10 convert spreadsheet to comma seperated Office 2019
Novice
 
Join Date: Jun 2017
Location: suburban Chicago
Posts: 25
ProudLiberal is on a distinguished road
Default

Save as CSV file
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert spreadsheet to comma seperated How to convert document columns to excel spreadsheet davidjm Word 2 06-04-2018 11:03 PM
Mac 2011 - When I close a spreadsheet, there is a blank spreadsheet left on dock. wvinyard Excel 0 07-27-2017 11:32 AM
convert spreadsheet to comma seperated Add a comma mbesspiata Excel 7 06-09-2014 03:36 AM
convert spreadsheet to comma seperated Convert Spreadsheet to Database Table mebjen Excel Programming 1 11-15-2013 11:21 PM
convert spreadsheet to comma seperated thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM


All times are GMT -7. The time now is 10:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft