uzuria Posted June 23, 2007 Share Posted June 23, 2007 Hi guys! I'm developing an excel spreadsheet for an easy populate import, but am having a problem. When I save it as tab delimited, the table messes up and some cells become distorted. I think this is due to product descriptions with paragraph gaps, but I'm not sure. But basically I end up with big gaps in my table and the products don't match up any more. Does anyone know how I can solve this problem? It works when I save it as a .csv file but not .txt :( Link to comment Share on other sites More sharing options...
PD_Steve Posted June 24, 2007 Share Posted June 24, 2007 .csv and .txt are basically the same thing. Save as .csv and rename to .txt and upload :). CSV just means comma seperated values and is a text file with commas seperating the fields in pretty much the same way the text file would. My Toolbox: Crimson Editor, Adobe Photoshop CS2.0, Expression Web, Macromedia Suite 8.0, Cinema 4D, Nvu. Link to comment Share on other sites More sharing options...
ctec2001 Posted August 20, 2007 Share Posted August 20, 2007 Hi guys! I'm developing an excel spreadsheet for an easy populate import, but am having a problem. When I save it as tab delimited, the table messes up and some cells become distorted. I think this is due to product descriptions with paragraph gaps, but I'm not sure. But basically I end up with big gaps in my table and the products don't match up any more. Does anyone know how I can solve this problem? It works when I save it as a .csv file but not .txt :( When in Excel, Go to File- Save AS then change the File type to Tab Delimited (txt). Hope this helps. Do or Do Not, there is no try. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.