Save Excel file to Lotus123 when there is no WK4 or Lotus option in the drop down

[Annie S]

Just started a new job and have 500+ contacts that I have in excel format. I have renamed all of the columns and was ready to import when I hit a brick wall. Unfortunately there is no option in the drop down to save the file as Lotus123 (WK4). Any options would be appreciated. Change settings etc. Thanks for being a lifesaver!

 

[cyrilbrd]

Hi, you forgot to mention what version of Excel you are presently using.
Please read this: link.

 

[Annie S]

Excel 2007

 

[cyrilbrd]

Excel 2007

If you are using Excel 2007 or higher it no longer supports savings as 1-2-3

Please read the link posted above.
Save as CSV might be the easiest way around.

 

[Annie S]

Thanks! Frustrating. Found a file format converter but that says it converted the file to WK4. But there is no way to actually see if it was successful and don't want to mess up the program at work unless I know it is correct. Appreciate your suggestions and input!